9Uploads
2k+Views
630Downloads
Whole school
![hps2012](https://d2w4qhtqw2dbsq.cloudfront.net/profile_live/4619764/small.jpg)
Visual Map Writer
Instant visual maps / MAGs for reading, writing and maths
Enter KS1 outcomes and current KS2 attainment and your visual maps are automatically created for you
Video showcases entire suite, including this tool
![hps2012](https://d2w4qhtqw2dbsq.cloudfront.net/profile_live/4619764/small.jpg)
Prior Attainment Groups Analysis
This will create PAG datasets for scrutiny, supporting senior leaders produce data for appraisal, strategic planning, inspection and reporting to governors.
Analysis by multiple subgroups for all three subjects.
Instant - it will take you about 15min to enter your pupil data, and the numbers are crunched for you as you type!
Video showcases complete suite, including this tool.
![hps2012](https://d2w4qhtqw2dbsq.cloudfront.net/profile_live/4619764/small.jpg)
Reading Writing Maths Data Analysis
Analysis of the groups of pupils who attained the expected standard in all three subjects combined at the end of KS1. Grid shows which of these children are on track to attain RWM at end of KS2, and which ones have slipped behind.
Similarly, will identify pupils who did not attain RWM at KS1 who are now on track to attain RWM at KS2.
Detailed analysis by subgroup.
Video showcases complete suite, including this tool.
![hps2012](https://d2w4qhtqw2dbsq.cloudfront.net/profile_live/4619764/small.jpg)
Data Analysis - Visual Maps - Tracking
This file contains ALL of the features in my other tools:
Visual Map Writer
Prior Attainment Group Analysis
Detailed Analysis of All Subjects
Reading, Writing & Maths Combined Analysis
With this tool, you can access all of the features from one set of data.
Two files are included:
V1.2 - this is not a macro enabled file, and does not include any macros
V1.3 - this is a macro enabled file, and if you allow macros, has the added functionality of exporting reports to word documents
![hps2012](https://d2w4qhtqw2dbsq.cloudfront.net/profile_live/4619764/small.jpg)
Detailed Data Analysis
Detailed analysis of progress and attainment in reading, writing and maths by pupil subgroup.
Rich sets of data from your relatively quick and easy data entry!
Video showcases the complete suite, including this tool.
![hps2012](https://d2w4qhtqw2dbsq.cloudfront.net/profile_live/4619764/small.jpg)
UPDATED 2021 PAG Calculator (Prior Attainment Group Calculator)
UPDATED February 2021
This excel sheet will automatically report the PAG group to which a pupil belongs based on KS1 data you enter. It will also:
calculate their expected KS2 score for 2018/2019 (the most recent reportable data as of Feb 2021)
calculate progress (0 being the expected) for each pupil for each subject
calculate overall progress for the school for each subject
“All those working with schools and colleges, such as Ofsted, Department for Education regional teams and local authorities, should use data from previous years when assessing school and college performance, and not the 2020 data.”*
https://www.gov.uk/government/publications/coronavirus-covid-19-school-and-college-performance-measures/coronavirus-covid-19-school-and-college-accountability
![hps2012](https://d2w4qhtqw2dbsq.cloudfront.net/profile_live/4619764/small.jpg)
Prior Attainment Group (PAG) Calculator
This excel sheet will automatically report the PAG group to which a pupil belongs based on KS1 data you enter. It will also return results to show you what the average KS2 result was for pupils in the same PAG in 2017, for Reading, Writing and Maths.